Metadata Search

The data model may contain a reasonable amount of data sources, having hundreds or thousands of tables and procedures. Each table may contain hundreds of columns. This view is designed to provide the user with metadata searching capabilities:

• A particular item in the data model can be found by the fully qualified name (FQN) (e.g. myschema.mytable). By default, it is simple 'contains search'.
• The search engine is case insensitive.
• The '*' (asterisk) character is supported as a wildcard for any string. For example, a query 'a*' searches for all items starting with 'a'.
• The following metadata object types are supported:
  • schema
  • table/view
  • column
  • procedure
  • procedure parameter
• The details of the items can be obtained by 'Double clicking' on a particular item or by selecting 'View Details' from Right Click Menu .

See also:

• Analytical Storage
• Data Source Schema